Create a table

CREATE TABLE tablename (column_name DATATYPE(NUMBER));

Description

Creates a new table

Arguments

String tablename

The name of the table you want to create.

String column_name

The name of the column(s) you want to add to the table.

Datatype DATATYPE

The type of data that should be stored ie NUMBER, DATE, VARCHAR etc.

Examples

Example 1

CREATE TABLE users (
id NUMBER(4),
firstname VARCHAR(30));